1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10
11 namespace SoftQuanLyNhaHang.Controllers
12 {
13 class Kho_SpKiemKhoCtrl
14 {
15 //them moi
16 public static int InsertKho_SpKiemKho(int _IdKho_SpKiemKho, int _IdKho_KiemKho, string _IdKhoStr, string _MaSanPham, float _SoLuongTrongKho, float _SoLuongKiemKho, string _TrangThai, DateTime _NgayTaoThucHien, int _NhanVienId, string _GhiChu, string _TenSanPham, int _DonViTinhId)
17 {
18 try
19 {
20 Models.Kho_SpKiemKhoMod kho = new Models.Kho_SpKiemKhoMod( _IdKho_SpKiemKho, _IdKho_KiemKho, _IdKhoStr, _MaSanPham, _SoLuongTrongKho, _SoLuongKiemKho, _TrangThai, _NgayTaoThucHien, _NhanVienId, _GhiChu, _TenSanPham, _DonViTinhId);
21 return kho.InsertKho_SpKiemKho();
22 }
23 catch
24 {
25 return 0;
26 }
27 }
28
29 //update
30 public static int UpdateKho_SpKiemKho(int _IdKho_SpKiemKho, int _IdKho_KiemKho, string _IdKhoStr, string _MaSanPham, float _SoLuongTrongKho, float _SoLuongKiemKho, string _TrangThai, DateTime _NgayTaoThucHien, int _NhanVienId, string _GhiChu, string _TenSanPham, int _DonViTinhId)
31 {
32 try
33 {
34 Models.Kho_SpKiemKhoMod kho = new Models.Kho_SpKiemKhoMod(_IdKho_SpKiemKho, _IdKho_KiemKho, _IdKhoStr, _MaSanPham, _SoLuongTrongKho, _SoLuongKiemKho, _TrangThai, _NgayTaoThucHien, _NhanVienId, _GhiChu, _TenSanPham, _DonViTinhId);
35 return kho.UpdateKho_SpKiemKho();
36 }
37 catch
38 {
39 return 0;
40 }
41 }
42
43
44 //xoa
45 public static int DeleteKho_SpKiemKho(int _IdKho_SpKiemKho)
46 {
47 try
48 {
49 Models.Kho_SpKiemKhoMod kho = new Models.Kho_SpKiemKhoMod(_IdKho_SpKiemKho);
50 return kho.DeleteKho_SpKiemKho();
51 }
52 catch
53 {
54 return 0;
55 }
56 }
57
58 //danh sach
59 public static DataSet FillDataSet_getKho_SpKiemKho_Search( int _IdKho_SpKiemKho, int _IdKho_KiemKho, string _IdKhoStr, string _MaSanPham, float _SoLuongTrongKho, float _SoLuongKiemKho, string _TrangThai, DateTime _NgayTaoThucHien, int _NhanVienId, string _GhiChu,string _TenSanPham,int _DonViTinhId,int _PageSize, int _PageIndex)
60 {
61 try
62 {
63 Models.Kho_SpKiemKhoMod kho = new Models.Kho_SpKiemKhoMod(_IdKho_SpKiemKho, _IdKho_KiemKho, _IdKhoStr, _MaSanPham, _SoLuongTrongKho, _SoLuongKiemKho, _TrangThai, _NgayTaoThucHien, _NhanVienId, _GhiChu, _TenSanPham, _DonViTinhId,_PageSize, _PageIndex);
64 return kho.FillDataSet_getKho_SpKiemKho_Search();
65 }
66 catch
67 {
68 return null;
69 }
70 }
71
72 //danh sach kiem kho
73 public static DataSet FillDataSet_getKho_SpKiemKho_ByIdKhiemKho(int _IdKho_SpKiemKho, int _IdKho_KiemKho, int _PageSize, int _PageIndex)
74 {
75 try
76 {
77 Models.Kho_SpKiemKhoMod kho = new Models.Kho_SpKiemKhoMod(_IdKho_SpKiemKho, _IdKho_KiemKho, _PageSize, _PageIndex);
78 return kho.FillDataSet_getKho_SpKiemKho_ByIdKhiemKho();
79 }
80 catch
81 {
82 return null;
83 }
84 }
85
86 //san pham da duoc kiem kho roi hay chua
87 public static DataSet FillDataSet_getKho_SpKiemKho_KiemTraDaTonTai(int _IdKho_SpKiemKho, int _IdKho_KiemKho, string _MaSanPham, string _TrangThai)
88 {
89 try
90 {
91 Models.Kho_SpKiemKhoMod kho = new Models.Kho_SpKiemKhoMod(_IdKho_SpKiemKho, _IdKho_KiemKho, _MaSanPham, _TrangThai);
92 return kho.FillDataSet_getKho_SpKiemKho_KiemTraDaTonTai();
93 }
94 catch
95 {
96 return null;
97 }
98 }
99
100 }
101 }